Bentley Map can be used to import Microsoft Excel files using the ODBC mechanism. As with the Access example, setup an ODBC data source using the Excel drivers to point to the file of interest. Create a VRT file as below. The VRT file is the same as the ODBC example above except that the ODBC data source now points to the Excel file as opposed to the Access database.

<OGRVRTDataSource>
 <OGRVRTLayer name="town_aus">
  <SrcDataSource>ODBC:town_aus</SrcDataSource>
   <SrcLayer>City</SrcLayer> 
  <GeometryType>wkbPoint</GeometryType>
  <LayerSRS>WGS84</LayerSRS>
  <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/>
 </OGRVRTLayer> 
</OGRVRTDataSource>

In the Excel file, create a named range that specifies the area of the spreadsheet to be used for the import. The SrcLayer (City) is the name of the named range in the Excel spreadsheet.